Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	268
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	25.2 KiB
Average record size in memory	96.5 B

Variable types

NUM	9
UNSUPPORTED	1
CAT	1
BOOL	1

Reproduction

Analysis started	2020-08-18 16:10:51.374240
Analysis finished	2020-08-18 16:11:29.258172
Duration	37.88 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Outcome` has constant value "1"	Constant
`winner` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Pregnancies` has 38 (14.2%) zeros	Zeros
`Insulin` has 138 (51.5%) zeros	Zeros

Pregnancies
Real number (ℝ_≥0)

ZEROS

Distinct count	17
Unique (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.865671641791045
Minimum	0
Maximum	17
Zeros	38
Zeros (%)	14.2%
Memory size	2.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1.75
median	4
Q3	8
95-th percentile	11
Maximum	17
Range	17
Interquartile range (IQR)	6.25

Descriptive statistics

Standard deviation	3.741239044
Coefficient of variation (CV)	0.7689049569
Kurtosis	-0.441643254
Mean	4.865671642
Median Absolute Deviation (MAD)	3
Skewness	0.5037492166
Sum	1304
Variance	13.99686958

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	38	14.2%
1	29	10.8%
3	27	10.1%
7	25	9.3%
4	23	8.6%
8	22	8.2%
5	21	7.8%
2	19	7.1%
9	18	6.7%
6	16	6.0%
Other values (7)	30	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38	14.2%
1	29	10.8%
2	19	7.1%
3	27	10.1%
4	23	8.6%

Value	Count	Frequency (%)
17	1	0.4%
15	1	0.4%
14	2	0.7%
13	5	1.9%
12	4	1.5%

Glucose
Real number (ℝ_≥0)

Distinct count	103
Unique (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	142.30223880597015
Minimum	78
Maximum	199
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	78
5-th percentile	98.05
Q1	119
median	140
Q3	167
95-th percentile	189.65
Maximum	199
Range	121
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	29.48881072
Coefficient of variation (CV)	0.2072266112
Kurtosis	-0.9424872734
Mean	142.3022388
Median Absolute Deviation (MAD)	23
Skewness	0.09273334353
Sum	38137
Variance	869.5899575

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
125	7	2.6%
158	6	2.2%
115	6	2.2%
129	6	2.2%
128	6	2.2%
173	5	1.9%
140	5	1.9%
181	5	1.9%
109	5	1.9%
146	5	1.9%
Other values (93)	212	79.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
78	1	0.4%
80	1	0.4%
84	1	0.4%
85	1	0.4%
88	1	0.4%

Value	Count	Frequency (%)
199	1	0.4%
198	1	0.4%
197	3	1.1%
196	3	1.1%
195	2	0.7%

BloodPressure
Real number (ℝ_≥0)

Distinct count	38
Unique (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	75.24253731343283
Minimum	30
Maximum	114
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	30
5-th percentile	56.7
Q1	68
median	74
Q3	82
95-th percentile	94
Maximum	114
Range	84
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	11.92976247
Coefficient of variation (CV)	0.1585507732
Kurtosis	1.281644254
Mean	75.24253731
Median Absolute Deviation (MAD)	8
Skewness	0.09964127194
Sum	20165
Variance	142.3192325

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
74	33	12.3%
70	23	8.6%
76	18	6.7%
78	17	6.3%
72	16	6.0%
64	13	4.9%
80	13	4.9%
82	13	4.9%
84	12	4.5%
68	12	4.5%
Other values (28)	98	36.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
30	1	0.4%
40	1	0.4%
48	1	0.4%
50	5	1.9%
52	3	1.1%

Value	Count	Frequency (%)
114	1	0.4%
110	2	0.7%
108	1	0.4%
106	1	0.4%
104	2	0.7%

SkinThickness
Real number (ℝ_≥0)

Distinct count	42
Unique (%)	15.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.029850746268657
Minimum	7
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	7
5-th percentile	19
Q1	27
median	27
Q3	36
95-th percentile	46
Maximum	99
Range	92
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	8.914861806
Coefficient of variation (CV)	0.2872995387
Kurtosis	12.42011205
Mean	31.02985075
Median Absolute Deviation (MAD)	4
Skewness	2.059665099
Sum	8316
Variance	79.47476103

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
27	95	35.4%
32	14	5.2%
30	9	3.4%
33	9	3.4%
39	8	3.0%
36	8	3.0%
37	8	3.0%
35	8	3.0%
29	7	2.6%
41	7	2.6%
Other values (32)	95	35.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	1	0.4%
12	1	0.4%
13	1	0.4%
14	2	0.7%
15	1	0.4%

Value	Count	Frequency (%)
99	1	0.4%
63	1	0.4%
56	1	0.4%
51	1	0.4%
49	3	1.1%

Insulin
Real number (ℝ_≥0)

ZEROS

Distinct count	93
Unique (%)	34.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	100.33582089552239
Minimum	0
Maximum	846
Zeros	138
Zeros (%)	51.5%
Memory size	2.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	167.25
95-th percentile	366.5
Maximum	846
Range	846
Interquartile range (IQR)	167.25

Descriptive statistics

Standard deviation	138.6891247
Coefficient of variation (CV)	1.382249365
Kurtosis	4.360492769
Mean	100.3358209
Median Absolute Deviation (MAD)	0
Skewness	1.843831487
Sum	26890
Variance	19234.67332

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	138	51.5%
130	6	2.2%
180	4	1.5%
156	3	1.1%
175	3	1.1%
194	2	0.7%
125	2	0.7%
225	2	0.7%
220	2	0.7%
210	2	0.7%
Other values (83)	104	38.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	138	51.5%
14	1	0.4%
29	1	0.4%
36	1	0.4%
48	1	0.4%

Value	Count	Frequency (%)
846	1	0.4%
600	1	0.4%
579	1	0.4%
543	1	0.4%
540	1	0.4%

BMI
Real number (ℝ_≥0)

Distinct count	148
Unique (%)	55.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35.39813432835821
Minimum	22.9
Maximum	67.1
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	22.9
5-th percentile	26.535
Q1	30.9
median	34.275
Q3	38.775
95-th percentile	46.59
Maximum	67.1
Range	44.2
Interquartile range (IQR)	7.875

Descriptive statistics

Standard deviation	6.590915342
Coefficient of variation (CV)	0.1861938621
Kurtosis	2.101668987
Mean	35.39813433
Median Absolute Deviation (MAD)	3.775
Skewness	1.027526692
Sum	9486.7
Variance	43.44016505

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
32.9	8	3.0%
31.6	7	2.6%
33.3	6	2.2%
30.5	5	1.9%
32	5	1.9%
31.2	5	1.9%
32.4	4	1.5%
30.4	4	1.5%
43.3	4	1.5%
34.3	4	1.5%
Other values (138)	216	80.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
22.9	1	0.4%
23.3	1	0.4%
23.4	1	0.4%
23.5	1	0.4%
23.8	1	0.4%

Value	Count	Frequency (%)
67.1	1	0.4%
59.4	1	0.4%
55	1	0.4%
53.2	1	0.4%
52.9	1	0.4%

DiabetesPedigreeFunction
Real number (ℝ_≥0)

Distinct count	231
Unique (%)	86.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5505
Minimum	0.08800000000000001
Maximum	2.42
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	0.088
5-th percentile	0.1517
Q1	0.2625
median	0.449
Q3	0.728
95-th percentile	1.224
Maximum	2.42
Range	2.332
Interquartile range (IQR)	0.4655

Descriptive statistics

Standard deviation	0.3723544836
Coefficient of variation (CV)	0.676393249
Kurtosis	4.559082526
Mean	0.5505
Median Absolute Deviation (MAD)	0.206
Skewness	1.722373119
Sum	147.534
Variance	0.1386478614

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.254	4	1.5%
0.258	3	1.1%
0.583	2	0.7%
0.302	2	0.7%
0.238	2	0.7%
0.24	2	0.7%
0.26	2	0.7%
0.27	2	0.7%
0.259	2	0.7%
0.328	2	0.7%
Other values (221)	245	91.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.088	1	0.4%
0.121	1	0.4%
0.127	2	0.7%
0.128	1	0.4%
0.129	2	0.7%

Value	Count	Frequency (%)
2.42	1	0.4%
2.288	1	0.4%
2.137	1	0.4%
1.893	1	0.4%
1.394	1	0.4%

Age
Real number (ℝ_≥0)

Distinct count	45
Unique (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	37.06716417910448
Minimum	21
Maximum	70
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	21
5-th percentile	22
Q1	28
median	36
Q3	44
95-th percentile	57.65
Maximum	70
Range	49
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	10.96825365
Coefficient of variation (CV)	0.2959021521
Kurtosis	-0.3479372743
Mean	37.06716418
Median Absolute Deviation (MAD)	8
Skewness	0.5816458715
Sum	9934
Variance	120.3025882

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
25	14	5.2%
31	13	4.9%
29	13	4.9%
41	13	4.9%
43	11	4.1%
22	11	4.1%
38	10	3.7%
28	10	3.7%
36	10	3.7%
33	10	3.7%
Other values (35)	153	57.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21	5	1.9%
22	11	4.1%
23	7	2.6%
24	8	3.0%
25	14	5.2%

Value	Count	Frequency (%)
70	1	0.4%
67	1	0.4%
66	2	0.7%
62	2	0.7%
61	1	0.4%

Outcome
Boolean

CONSTANT
REJECTED

Distinct count	1
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

1	268

Frequency Table

Value	Count	Frequency (%)
1	268	100.0%

winner
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	2.2 KiB

weights
Real number (ℝ)

Distinct count	150
Unique (%)	56.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-9.554585820895502
Minimum	-18.83249999999996
Maximum	-0.1340000000000001
Zeros	0
Zeros (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	-18.8325
5-th percentile	-17.001325
Q1	-13.018125
median	-9.428
Q3	-5.976
95-th percentile	-2.719725
Maximum	-0.134
Range	18.6985
Interquartile range (IQR)	7.042125

Descriptive statistics

Standard deviation	4.421485435
Coefficient of variation (CV)	-0.4627605548
Kurtosis	-0.8368224386
Mean	-9.554585821
Median Absolute Deviation (MAD)	3.50725
Skewness	-0.05805241807
Sum	-2560.629
Variance	19.54953346

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-9.295	5	1.9%
-18.235	5	1.9%
-4.6705	4	1.5%
-6.7945	4	1.5%
-4.073	4	1.5%
-4.914	4	1.5%
-12.526	4	1.5%
-11.198	4	1.5%
-7.9895	4	1.5%
-6.5735	3	1.1%
Other values (140)	227	84.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-18.8325	2	0.7%
-18.235	5	1.9%
-17.881	1	0.4%
-17.6375	1	0.4%
-17.2835	2	0.7%

Value	Count	Frequency (%)
-0.134	2	0.7%
-0.7315	1	0.4%
-1.0855	2	0.7%
-1.329	1	0.4%
-1.683	1	0.4%

Severity of diabetes
Categorical

Distinct count	4
Unique (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

HIGH	82
MODERATE	72
ALARMING	70
LOW	44

Common Values
Length

Value	Count	Frequency (%)
HIGH	82	30.6%
MODERATE	72	26.9%
ALARMING	70	26.1%
LOW	44	16.4%

Length

Max length	8
Median length	8
Mean length	5.955223881
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome	winner	weights	Severity of diabetes
0	6	148	72	35	0	33.60	0.627	50	1	(2, 5)	-5.0245	ALARMING
1	8	183	64	27	0	23.30	0.672	32	1	(0, 3)	-1.9265	ALARMING
2	0	137	40	35	168	43.10	2.288	33	1	(12, 0)	-11.5520	MODERATE
3	3	78	50	32	88	31.00	0.248	26	1	(12, 9)	-16.9295	LOW
4	2	197	70	45	543	30.50	0.158	53	1	(14, 4)	-15.8450	LOW
5	8	125	96	27	0	34.25	0.232	54	1	(5, 3)	-6.6840	HIGH
6	10	168	74	27	0	38.00	0.537	34	1	(4, 5)	-6.9275	HIGH
7	1	189	60	23	846	30.10	0.398	59	1	(13, 4)	-14.8935	LOW
8	5	166	72	19	175	25.80	0.587	51	1	(0, 2)	-1.3290	ALARMING
9	7	100	74	27	0	30.00	0.484	32	1	(7, 4)	-9.1845	HIGH

Last rows

	Pregnancies	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigreeFunction	Age	Outcome	winner	weights	Severity of diabetes
258	3	187	70	22	200	36.4	0.408	36	1	(14, 6)	-17.0400	LOW
259	6	162	62	27	0	24.3	0.178	50	1	(0, 5)	-3.1215	ALARMING
260	4	136	70	27	0	31.2	1.182	22	1	(11, 8)	-15.3805	LOW
261	0	181	88	44	510	43.3	0.222	26	1	(11, 5)	-13.5880	MODERATE
262	8	154	78	32	0	32.4	0.443	45	1	(2, 5)	-5.0245	ALARMING
263	1	128	88	39	110	36.5	1.057	37	1	(8, 6)	-11.3310	MODERATE
264	0	123	72	27	0	36.3	0.258	52	1	(8, 3)	-9.5385	HIGH
265	6	190	92	27	0	35.5	0.278	66	1	(0, 7)	-4.3165	ALARMING
266	9	170	74	31	0	44.0	0.403	43	1	(2, 4)	-4.4270	ALARMING
267	1	126	60	27	0	30.1	0.349	47	1	(11, 7)	-14.7830	LOW

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows